UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yfg1pYagIq7d4x/KJnke4It4IaJj98VzIQgjY9I4yYQ='
WHERE
key_id = '3c664970bf0f528c28b30f8c3ba95bb08634f1d4d525443378fd1ec6b367a01e'
AND (
token = 'yfg1pYagIq7d4x/KJnke4It4IaJj98VzIQgjY9I4yYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)