UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bj7Mcn0Qe0h2AnztIKAt8dyEePvQJz8B1DVFcek9pm8='
WHERE
key_id = '221e451d25932df0aa50e9307006d8244123d1ea62673a8fb4fccec841010d19'
AND (
token = 'bj7Mcn0Qe0h2AnztIKAt8dyEePvQJz8B1DVFcek9pm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)