UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qKfqH9oBpqAEhjlq3AtHVCR0d6gnNRjA+kSpzfycVgs='
WHERE
key_id = '77f6932701a11bec8ea1f1e6edc7b0216177fc1715329cc4cfec1265f5ad580e'
AND (
token = 'qKfqH9oBpqAEhjlq3AtHVCR0d6gnNRjA+kSpzfycVgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)