UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e2mGWMb5xNS4x9viQqtcsjTPvWaexZXklnpxkPBG8Js='
WHERE
key_id = 'a3fca33a4221915812618fd755c7e50878770bc7bb691a52176f1ba2ea0b2b4a'
AND (
token = 'e2mGWMb5xNS4x9viQqtcsjTPvWaexZXklnpxkPBG8Js='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)