UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/BhghcdDo+ieLEw7NWKITSIgt+nBDLrs5eEgOtBg3yc='
WHERE
key_id = '2e530c185ee0cd02e2588f3d01eb147d7648a30b5c2265b05643df02fe61c806'
AND (
token = '/BhghcdDo+ieLEw7NWKITSIgt+nBDLrs5eEgOtBg3yc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)