UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yvz3cqU7zR0I9p7CKD/e+E/oVoNp4osSHUtALbJGYd0='
WHERE
key_id = '39b5badfaded49728ece4b86bb2c97ef37f6324173475373d0d379192da0d266'
AND (
token = 'yvz3cqU7zR0I9p7CKD/e+E/oVoNp4osSHUtALbJGYd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)