UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ASEA8dI++OAcgedfX01K2XgHAtw4orV+DhYcBLEBixM='
WHERE
key_id = 'd9a6d4e8ecc09a7b7ec9786a2e101031d338a3440c72bfb1940526260ce4f3f1'
AND (
token = 'ASEA8dI++OAcgedfX01K2XgHAtw4orV+DhYcBLEBixM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)