UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ofp+JbLRrqNWmK9nfu9V9NWwRG8+woqBUbQy/PKEL+o='
WHERE
key_id = '9fc0199af66fb57c6fd8864f6ec7729eea6444f1205d749314a93adac5a935d2'
AND (
token = 'ofp+JbLRrqNWmK9nfu9V9NWwRG8+woqBUbQy/PKEL+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)