UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pWBdYTXIOrnGnl/Wl1m/1q+cim2QAdyuqG9t4arYKFA='
WHERE
key_id = 'd6c2eb4814723e8af8cea79b393b534b79236d4593e1e54d89d796d4d382078b'
AND (
token = 'pWBdYTXIOrnGnl/Wl1m/1q+cim2QAdyuqG9t4arYKFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)