UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prO0G0R5WM19/5YD9GzW6hx7jNqNydhzSUKhzZy73dY='
WHERE
key_id = '87e5b117939adce1c82abbb20401b356f01d29fd1da24ebd41b2de3a99d247a9'
AND (
token = 'prO0G0R5WM19/5YD9GzW6hx7jNqNydhzSUKhzZy73dY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)