UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RWZWAa8h9QBHYCX9fO3Jc9oQjAdZJM9TabTjIdyLi0g='
WHERE
key_id = '78b9332ef092acef3fa8e15e6c145636c3085666a94dc76f2b713c33b0aa4bbd'
AND (
token = 'RWZWAa8h9QBHYCX9fO3Jc9oQjAdZJM9TabTjIdyLi0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)