UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'znpRXyOJD44T32yjkeAYuvB0bncO+siOJI66YwQUdIw='
WHERE
key_id = '798cf5ada0fdef2efddb83e0d0e0f04b7683ff30058633e55aa9e8a1e2f3c0f7'
AND (
token = 'znpRXyOJD44T32yjkeAYuvB0bncO+siOJI66YwQUdIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)