UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oYc6ZSYVnUL2Kp3qFuy2EaVxUUIqXkuXSzE6hqwIeeo='
WHERE
key_id = '3adf8a8d38d94ff47e5f905e1a7d24be6a23f3b337aa2677d99077b629bae275'
AND (
token = 'oYc6ZSYVnUL2Kp3qFuy2EaVxUUIqXkuXSzE6hqwIeeo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)