UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xx07Z6SMBn708N7PMh3zLpk0Z7cF8mLCEoexDtAmSDg='
WHERE
key_id = '52bfa782745f383d686df590711d8cf4a96f6b42abfa4187113e392f3fd50757'
AND (
token = 'xx07Z6SMBn708N7PMh3zLpk0Z7cF8mLCEoexDtAmSDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)