UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KJwwtSoErBE9cfHzQxQke8rcGHw572NiFgsOibJV2IA='
WHERE
key_id = 'f23a51c8b3c0a07e5ef96a5c039129bd0d60b3d2e4bd1b192ce96cd159dc50e4'
AND (
token = 'KJwwtSoErBE9cfHzQxQke8rcGHw572NiFgsOibJV2IA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)