UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FntIfhigLRL1lu0bVSV+JdkBf1AC0kJkf5iBMb5CcYA='
WHERE
key_id = 'ca420efd744ed422b519a64285d124b67a98075da4eb1eac52c65320c2d7db0f'
AND (
token = 'FntIfhigLRL1lu0bVSV+JdkBf1AC0kJkf5iBMb5CcYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)