UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0LyAcs9OmwcZ/V/JsGuNd3IhjBnbJ3vlzHMX03jD6VA='
WHERE
key_id = 'ac7edea2345e2d62fc648611de173d15dc74c149b5710799342742d933820b9c'
AND (
token = '0LyAcs9OmwcZ/V/JsGuNd3IhjBnbJ3vlzHMX03jD6VA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)