UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A6YdvosAvrkqWqNDTuoueESCIdqLgHXz4FYR4I7emrU='
WHERE
key_id = '07b1e7883ffcb36aa5cc20cf998ebe8ce04bed9179a9590b1648c869cb4ae818'
AND (
token = 'A6YdvosAvrkqWqNDTuoueESCIdqLgHXz4FYR4I7emrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)