UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/oFoufqSHqP5Ucq+N0k0pkZSrwKtLjn1kUwr7tXxyKM='
WHERE
key_id = '7930e347f8fc85278014c594d26b954835f9e9a96c40945d656f5d03585a84fc'
AND (
token = '/oFoufqSHqP5Ucq+N0k0pkZSrwKtLjn1kUwr7tXxyKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)