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