UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4uz0XTapHseUfFyIOhVyINEkheTO9p5U4D1voW5HUg='
WHERE
key_id = '49fd8113c4a1d36c063c50a94a7c82b53b1fd164000831e3b996777ba19111d0'
AND (
token = 'D4uz0XTapHseUfFyIOhVyINEkheTO9p5U4D1voW5HUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)