UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Dy2Cfh6KgwImTiX4AE1j2fMOnitvpzAOvsxdOYUp5s='
WHERE
key_id = '2df45910a4a8c79ac747450ac948bd99ed8fb62e838b4e8c6f4f65d915781788'
AND (
token = '9Dy2Cfh6KgwImTiX4AE1j2fMOnitvpzAOvsxdOYUp5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)