UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IqOyq0CXp2P8DEHk/c428YXjFj13jbdQAEWsh83i878='
WHERE
key_id = '9c6f7adbbc777f9ff006765fc727a1760b4b29729a67ae5154cd599e99befea5'
AND (
token = 'IqOyq0CXp2P8DEHk/c428YXjFj13jbdQAEWsh83i878='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)