UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ShMg7rjAPqXaEck6EPyxQokyZtYSTOFdIK+fyV0VTY8='
WHERE
key_id = '972ae3098482f3a08d88cb5e116f711875684e339df8dd77917d820a730933f2'
AND (
token = 'ShMg7rjAPqXaEck6EPyxQokyZtYSTOFdIK+fyV0VTY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)