UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Gms/yS2Be1aBOQhqRsXdMdfviKf8ZqrJ2pPGH3nJpw='
WHERE
key_id = 'd9a63d6c3eaa85bc68e51ef225cb3357507470f451a079e32c83497a029d0e85'
AND (
token = '9Gms/yS2Be1aBOQhqRsXdMdfviKf8ZqrJ2pPGH3nJpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)