UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XrT1yno3bAoX43zlITOKzueQkmPEtSNoEoyOqxBZpY0='
WHERE
key_id = '04ae6527cfb46ab1ab4aa5ec0a952c16a4f031c637b3337f6280607bd8227e8f'
AND (
token = 'XrT1yno3bAoX43zlITOKzueQkmPEtSNoEoyOqxBZpY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)