UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NIaSrd1nEvgJxztu9zXl4L5E+AUK/3AiR4x5N5uYBw0='
WHERE
key_id = 'b47247b31f16207d220e48ba020c5f0ece9d222ce825999f3bd86ef391fbf325'
AND (
token = 'NIaSrd1nEvgJxztu9zXl4L5E+AUK/3AiR4x5N5uYBw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)