UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KUx7UzP9FOSPE0JovchSqTf16fAfDQwOU9PrhvZZw/E='
WHERE
key_id = '8b9af2793d04a3b36c7e5dd55d45c8e471345cb33a51195fcab7978e93761c84'
AND (
token = 'KUx7UzP9FOSPE0JovchSqTf16fAfDQwOU9PrhvZZw/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)