UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SJgYWHOZVX7zT/M4WzyOPdKidfHpiPOioB40qmAfNuU='
WHERE
key_id = 'c02a99b4b0392c4cb9699440776062b296f8d859b607854431a58bea07420000'
AND (
token = 'SJgYWHOZVX7zT/M4WzyOPdKidfHpiPOioB40qmAfNuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)