UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TxS3LsANehmrelh67COs7JRvaEGPc1DJLve4JlN/MdA='
WHERE
key_id = 'b6776c8148bea4f12d13bdc4fb98c2678e7857108507e80b59439ac9aa7ea60d'
AND (
token = 'TxS3LsANehmrelh67COs7JRvaEGPc1DJLve4JlN/MdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)