UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zqJEaFz0oEFJ/Qi6Q3R1+wz9c1OgpaMTZH03wHXAhLA='
WHERE
key_id = 'a4bbd45ab949305bed6724a3a227684eba6f1f298988a497405169bac5177904'
AND (
token = 'zqJEaFz0oEFJ/Qi6Q3R1+wz9c1OgpaMTZH03wHXAhLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)